Andy McKenzie (6/18/2009)

---

Thanks for your help... I think I've found a solution!

Next question: I was able to restore one instance of my live environment to my test box with...

Hi Jacob

Here the alternatives you have

1. MS-SQL cluster on top of Veritas.

If your company or job has the money, you should go for this one. It allows you to have...

Robert Davis (6/17/2009)

---

That's not accurate at all. Big companies that are totally on SQL 2008 are the minority, not the majority.

Firthermore, certification is supposed to reflect the knowledge and experience...

If you go out looking for a new job as a DBA, you will likely see more employers looking for someone certified in SQL 2005 than in SQL 2008, at...

Hi Kruti

So far, I just passed 70-431 so I'm MCTS only but I've being...

Kruti

I am going to give you a different perspective. Why get a cert for an old product if you can spend your money now, on a recent product an platform?...

Antero Ruiz (6/15/2009)

---

Thanks for all your responses.

Yes, the users and managers are aware of this problem. Unfortunately, the company cannot afford more storage other than the 2TB they buy every...

I guess is for SQL2005, right? test this...

How's your memory allocation? how much RAM you're using on your server and how much SQL is requesting?

Look at the following counters:

Process: Private Bytes - SQL Server -...

because sometimes, depending...

If you do a Full+Tlog(s) > restore this way > Full+Subsequents Tlog(s) starting from oldest to newest.

If you do Full+Diff+Tlog(s) > restore this way > Full+most Recent Diff+Tlogs AFTER most...

Looks like a memory leak or problem. Just to be sure, download and patch your MS-SQL instance if possible You can also check the memory usage and processes via Performance...

Antero Ruiz (6/12/2009)

---

I have a large database (18TB) which will keep growing around 700GB to 1TB every month. I was wondering if there are any sugestions for the administration.

1. We...

ebinroy (6/8/2007)

---

hi all,

I am using SQL server 2005.The Log file size increased to 40GB,so I detach the DB and delete the log & created new log file.Can I...

Please check all these:

1. Database Mail must be enable (I guess it is, right?)

2. Service Broker needs to be enable in the database

3. The database mail external executable needs access...